Introduction to Database Search


There are a couple of ways to search for data within doogiePIM. The first is by using the Quick Search which is located under most of the section's list views.

heart See Quick Searching for more information.


There are times, however, that Quick Search doesn't give the results you need. Therefore, you could use the Database Search which is sectioned into a Full Search, Search by Field and a much more advanced SQL search.


       


The main advantage of using the Database Search over the Quick Search is that the Database Search will list the matching records so you can locate the record, export the list or print it. The Quick Search will only go to the first or next matching field so you don't know exactly how many matches you have. Plus the Quick Search only searches in the currently selected folder with the exception of the calendar.


The Full Search is an indexed search that will search for words in any part of your database. It isn't restricted by which field the text is in.


heart See Full Search and Indexing for more information.


The Database Search By Field is a good way to find text that matches any one of the fields in a database section. You could search for the home address country that matches "Netherlands" or

find URLs that end in ".co.uk".


heart See Search by Field for more information.


The Advanced SQL gives the user scripting control. This is designed for people with knowledge of SQL (Structured Query Language) and gives a great deal of flexibility.


heart See Advanced Search and SQL Reference for more information.


The results list view of the search can be used to export to CSV or you may print the list. You can go to a record from the result item which takes you to the correct section and record within doogiePIM in the main window.



Related Topics

Introduction to Searching and SQL

Simple Search

Advanced Database Search

Exporting Search Results

Managing SQL Scripts

SQL Reference